If your application uses floating - point types , but your requirements can be met using an exact decimal type 如果應(yīng)用程序使用浮點類型,但是只要使用十進制類型(
The string - to - decimal type conversions used in bulk insert follow the same rules as the transact - sql Bulk insert中使用的從字符串到十進制類型的轉(zhuǎn)換所遵從的規(guī)則與transact - sql
The jdbc decimal type represents a fixed - precision decimal value that holds values of at least the specified precision Jdbc decimal類型表示固定精度的十進制值,它保留指定精度以上的值。
Bulk insert supports string - to - decimal type conversion for strings representing numeric values that use scientific notation Bulk insert支持將使用科學(xué)計數(shù)法表示數(shù)值的字符串從字符串類型轉(zhuǎn)換為十進制類型。
The jdbc decimal type also maps to the sql server money and smallmoney types , which are specific fixed - precision decimal types that are stored in 8 and 4 bytes , respectively Jdbc decimal類型還映射到sql server money類型和smallmoney類型,這是固定精度的特定decimal類型,分別以8個和4個字節(jié)進行存儲。